-- @owner: z@wan005
-- @date: 2022/01/06
-- @testpoint: 自定义函数，datetime类型作为入参测试
@conn PrimaryDbBmode;
--step1；创建函数指定参数数据类型是datetime;expect:成功
drop function if exists func_datetime_0018;
create or replace function func_datetime_0018 (c1 datetime) returns datetime  as $$
        begin
                return (c1);
        end;
$$ language plpgsql;
/
--step2:调用函数;expect:成功
call func_datetime_0018('294277-01-09 04:00:00');
call func_datetime_0018(00000101235959.9::datetime);
--step3:清理环境;expect:成功
drop function  func_datetime_0018;